Using metadata defined libraries to access data or update table metadata might return the message:

The error can occur when you run any of the following:

• A LIBNAME statement that references the META LIBNAME engine
• The update table metadata action from within SAS^® Management Console, SAS^® Data Integration Studio, and other clients
• The METALIB procedure

The error can occur when a component of the Library definition, such as the DATASRC name for an ODBC data source, contains special characters, such as a blank space, hyphen, ampersand, and so on.

Follow one of these steps to help determine which component might be causing the problem.

• If experiencing the problem with a LIBNAME statement, add the option LIBDEBUG to the LIBNAME statement, and resubmit the statement. This option writes the underlying LIBNAME statement to the SAS log. Evaluate the structure of the generated LIBNAME statement and look for unquoted strings containing special characters.
  
  Here is an example:
  libname mylib meta library="ODBC Library Name" libdebug;
  The result looks similar to the following:
  LIBDEBUG: LIBNAME mylib ODBC DATASRC=DEMO-ODBC-DATASOURCE USER="sasdemo" PASSWORD="XXXXXXXX" ;
• If experiencing the problem with the METALIB procedure, add the TL=16383 option to the PROC METALIB statement as shown here:

Then, resubmit the step.

The result is trace data written to the SAS log. Look at the query_connect: db connect options for unquoted strings containing special characters:

To circumvent the issue, enclose the value in the metadata in double quotation marks. For example, if the data source name of an ODBC data source contains a hyphen, add quotation marks around the data source name in the Connection properties of your database server object. To make this change, complete these steps:

1. Open the Server Manager in SAS Management Console.
2. Select the server object that is associated with the library.
3. Open the Properties for the Connection, and click the Options tab.

Operating System and Release Information